package com.bosc.automationui.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.sql.Date;

@Entity
@Table(name = "etl_job")
public class ETLJob{

    @Column(name = "jobsessionid", nullable = false)
    private Integer jobSessionID;

    @Id
    @Column(name = "etl_job", nullable = false, length = 50)
    private String etlJob;

    @Column(name = "etl_system", nullable = false, length = 20)
    private String etlSystem;

    @Column(name = "etl_server", nullable = false, length = 10)
    private String etlServer;

    @Column(name = "description", length = 200)
    private String description;

    @Column(name = "frequency", length = 30)
    private String frequency;

    @Column(name = "jobtype", nullable = false, length = 2)
    private String jobType;

    @Column(name = "enable", nullable = false, length = 1)
    private String enable;

    @Column(name = "last_starttime", length = 19)
    private String lastStartTime;

    @Column(name = "last_endtime", length = 19)
    private String lastEndTime;

    @Column(name = "last_jobstatus", nullable = false, length = 20)
    private String lastJobStatus;

    @Column(name = "last_txdate", nullable = false)
    private Date lastTxDate;

    @Column(name = "last_filecnt")
    private Integer lastFileCnt;

    @Column(name = "last_cubestatus")
    private String lastCubeStatus;

    @Column(name = "cubeflag", length = 1)
    private String cubeFlag;

    @Column(name = "checkflag", length = 1)
    private String checkFlag;

    @Column(name = "autooff", length = 1)
    private String autoOff;

    @Column(name = "checkcalendar", length = 1)
    private String checkCalendar;

    @Column(name = "calendarbu")
    private String calendarBU;

    @Column(name = "runningscript")
    private String runningScript;

    @Column(name = "expectedrecord")
    private Integer expectedRecord;

    @Column(name = "checklaststatus", length = 1)
    private String checkLastStatus;

    @Column(name = "timetrigger", length = 1)
    private String timeTrigger;

    @Column(name = "jobresweight")
    private Integer jobResWeight;

    public Integer getJobSessionID() {
        return jobSessionID;
    }

    public void setJobSessionID(Integer jobSessionID) {
        this.jobSessionID = jobSessionID;
    }

    public String getEtlJob() {
        return etlJob;
    }

    public void setEtlJob(String etlJob) {
        this.etlJob = etlJob;
    }

    public String getEtlSystem() {
        return etlSystem;
    }

    public void setEtlSystem(String etlSystem) {
        this.etlSystem = etlSystem;
    }

    public String getEtlServer() {
        return etlServer;
    }

    public void setEtlServer(String etlServer) {
        this.etlServer = etlServer;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getFrequency() {
        return frequency;
    }

    public void setFrequency(String frequency) {
        this.frequency = frequency;
    }

    public String getJobType() {
        return jobType;
    }

    public void setJobType(String jobType) {
        this.jobType = jobType;
    }

    public String getEnable() {
        return enable;
    }

    public void setEnable(String enable) {
        this.enable = enable;
    }

    public String getLastStartTime() {
        return lastStartTime;
    }

    public void setLastStartTime(String lastStartTime) {
        this.lastStartTime = lastStartTime;
    }

    public String getLastEndTime() {
        return lastEndTime;
    }

    public void setLastEndTime(String lastEndTime) {
        this.lastEndTime = lastEndTime;
    }

    public String getLastJobStatus() {
        return lastJobStatus;
    }

    public void setLastJobStatus(String lastJobStatus) {
        this.lastJobStatus = lastJobStatus;
    }

    public Date getLastTxDate() {
        return lastTxDate;
    }

    public void setLastTxDate(Date lastTxDate) {
        this.lastTxDate = lastTxDate;
    }

    public Integer getLastFileCnt() {
        return lastFileCnt;
    }

    public void setLastFileCnt(Integer lastFileCnt) {
        this.lastFileCnt = lastFileCnt;
    }

    public String getLastCubeStatus() {
        return lastCubeStatus;
    }

    public void setLastCubeStatus(String lastCubeStatus) {
        this.lastCubeStatus = lastCubeStatus;
    }

    public String getCubeFlag() {
        return cubeFlag;
    }

    public void setCubeFlag(String cubeFlag) {
        this.cubeFlag = cubeFlag;
    }

    public String getCheckFlag() {
        return checkFlag;
    }

    public void setCheckFlag(String checkFlag) {
        this.checkFlag = checkFlag;
    }

    public String getAutoOff() {
        return autoOff;
    }

    public void setAutoOff(String autoOff) {
        this.autoOff = autoOff;
    }

    public String getCheckCalendar() {
        return checkCalendar;
    }

    public void setCheckCalendar(String checkCalendar) {
        this.checkCalendar = checkCalendar;
    }

    public String getCalendarBU() {
        return calendarBU;
    }

    public void setCalendarBU(String calendarBU) {
        this.calendarBU = calendarBU;
    }

    public String getRunningScript() {
        return runningScript;
    }

    public void setRunningScript(String runningScript) {
        this.runningScript = runningScript;
    }

    public Integer getExpectedRecord() {
        return expectedRecord;
    }

    public void setExpectedRecord(Integer expectedRecord) {
        this.expectedRecord = expectedRecord;
    }

    public String getCheckLastStatus() {
        return checkLastStatus;
    }

    public void setCheckLastStatus(String checkLastStatus) {
        this.checkLastStatus = checkLastStatus;
    }

    public String getTimeTrigger() {
        return timeTrigger;
    }

    public void setTimeTrigger(String timeTrigger) {
        this.timeTrigger = timeTrigger;
    }

    public Integer getJobResWeight() {
        return jobResWeight;
    }

    public void setJobResWeight(Integer jobResWeight) {
        this.jobResWeight = jobResWeight;
    }
}
